query=
-- _f_propiedades.php listar_propiedades()
SELECT
*
FROM propiedad
WHERE
web = 100 -- std
-- cond_empresa
AND cod_empresa != 0 -- p.
AND (
-- propiedades de empresas no excluidas de MLS
(
(web, cod_empresa) NOT IN (
SELECT web_cap, cod_empresa_cap
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 0
AND cod_propiedad IS NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE web = 100
AND cod_empresa = 0
AND cod_propiedad IS NOT NULL
AND estado = 'C'
)
)
AND
-- propiedades no excluidas de MLS a nivel global (por usuario administrador de MLS 20230626a)
(
cod_propiedad NOT IN (
SELECT cod_propiedad
FROM empresa_config_mls
WHERE estado = 'X'
)
)
)
-- 20141219 rbz [MLSxx] Inclusión propiedades de Re-max e In-Max en LP360
-- nop!
AND propiedad.cod_oficina = 0
AND ( cod_empresa != 1 OR 1=2 ) -- ceidemo 1 &&
AND propiedad.cod_propiedad NOT IN (0)
AND (
( propiedad.estado IN ('A','O','B') )
|| ( propiedad.estado IN ('V','R') AND fecha_ult_mod > '20240503' AND NOT 1=2 ) -- Vendidas y alquiladas se muestran en webs publicas n_dias despues de la operacion
|| ( propiedad.estado = 'V' AND 0 =1 )
|| ( propiedad.estado = 'R' AND 0 =1 )
|| ( propiedad.estado = '3' AND 0 =1 )
|| ( propiedad.estado = '4' AND 0 =1 )
|| ( propiedad.estado = 'C' AND 0 =1 )
-- || ( propiedad.estado = 'P' AND 1=2 ) -- Prospeccion
|| ( propiedad.estado = 'P' AND 0 =1 )
|| ( propiedad.estado = 'B' AND 0 =1 )
)
AND -- propiedades no publicadas
(
propiedad.publicar IN ('S','P') -- TIPO_WEB_PORTAL
)
AND (
( propiedad.tipo_operacion = '' ) -- El tipo_operacion de la propiedad coincide con el indicado por el usuario
|| ( propiedad.tipo_operacion IN ('V','A') && '' = 'X' ) -- El tipo_operacion de la propiedad es Venta o Alquiler y el indicado por el usuario es X
|| ( propiedad.tipo_operacion = 'X' && ('' = 'V' || '' = 'A') ) -- El tipo_operacion de la propiedad es X y el indicado por el usuario es Venta o Alquiler
|| ( '' = '' ) -- El usuario no ha seleccionado tipo_operacion, mostramos todo
-- [20180806d]
|| ( propiedad.tipo_operacion IN ('H') && '' = 'C' ) -- El tipo_operacion de la propiedad es Alquiler vacacional y el indicado por el usuario es C (alquiler de corta duracion)
)
AND (
cod_valoracion = ''
||
'' = ''
)
-- cond_pais
-- cond_zonas
AND ( propiedad.cod_metazona IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61 ,99) )
-- 20180806d
-- cond_metazonas_portales
-- cond_metazonas_portales: ERROR!! NO OBSERVADO PORTAL 100
AND (
( propiedad.metatipo_propiedad = '' ) -- el metatipo_propiedad es el seleccionado
||
( '' = '' )
)
AND (
( propiedad.tipo_propiedad IN (0) ) -- el tipo de propiedad es el seleccionado
||
( ( '0' = '' || '0' = 0 ) ) -- 20120820 rbz Incluimos negocios en home, además es necesario para que salgan cuando no se indica tipo_propiedad && tipo_propiedad < 200 ) -- No se seleccionó tipo_propiedad (página inicial) No pintamos parcelas, negocios...
||
( ( '0' = '' || '0' = 0 ) && '' = 3 ) -- inversiones
)
AND ( propiedad.superficie >= '' || '' = '' )
AND ( propiedad.superficie <= '' || '' = '' )
AND ( propiedad.superficie_util >= '' || '' = '' )
AND ( propiedad.superficie_util <= '' || '' = '' )
AND ( propiedad.superficie_parcela >= '' || '' = '' )
AND ( propiedad.superficie_parcela <= '' || '' = '' )
AND propiedad.fecha_alta <= '20240518'
AND
( -- Usuario busca Venta/Alquiler (o no selecciona tipo_operacion)
-- propiedad.tipo_operacion IN ('V','A','X')
( propiedad.precio_pvp <= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_pvp >= '' || propiedad.precio_pvp IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler <= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
&& ( propiedad.precio_alquiler >= '' || propiedad.precio_alquiler IS NULL || '' = '' || '' = '0' )
)
-- 20131223 rbz
-- 20130128 rbz
-- 20130916 rbz [20130131a]
-- 20130506 rbz
-- [20160430a]
-- 20131028 rbz [20131028a]
-- 20131220 rbz [20131220a]
-- 20130514 rbz [20130514a]
-- 20180305b
-- [3370-4320]
AND propiedad.num_fotos >= 1
AND cod_propiedad NOT IN (1111) -- propiedades_especialitas_excluidas
ORDER BY
CASE
WHEN web = 100 AND cod_empresa = 0 THEN 1 -- propiedades de la propia empresa-
ELSE 9
END,
CASE
WHEN web = 100 AND cod_empresa = 0 THEN prioridad -- propiedades de la propia empresa
-- ELSE 999 -- no deberia ser -1?
ELSE -1
END DESC
, -- 20220315 rbz Añado criterio prioridad (Thorsgren quería para que sus propiedades aparecieran antes que resales)
-- 20220315 rbz Añado este criterio para que las propiedades de MLS aparezcan ordenadas según la empresa asociada
cod_propiedad DESC -- 11
LIMIT 24 -- 24 = 24 - %
-- num_prop_slide= grupo_registros=2 num_max_propiedades_x_pagina=24
OFFSET 48 -- 3 offp
num_tuplas=
24
1.650.000€
Welcome to Casa Jazmine, a recently renovated, modern Andalusian villa located in the prestigious area of Nueva Andalucia, surrounded by renowned restaurants, boutique shops, and elite golf courses. This south/east facing property offers a blend of luxury, privacy, and convenience, making it an exceptional choice for discerning buyers.
The villa features an open plan living and kitchen area, elegantly designed with Italian stone and high-end finishes. It hosts four bedrooms and four bathrooms, including a guest house with its own amenities, ensuring comfort and privacy for all residents. The master suite, with its bespoke U-shaped imperial marble sink, provides direct access to the heated pool and barbecue area, facilitating a seamless indoor-outdoor lifestyle.
Outdoors, the property boasts a beautifully landscaped garden with LED lighting, a heated swimming pool with an automatic drainage system, and a pergola-covered dining area alongside a barbecue and wine fridge, perfect for entertaining. The garden's lemon tree and tasteful greenery add to the villa's serene ambiance.
Casa Jazmine is equipped with modern conveniences such as heated floors, a comprehensive sound system both indoors and outdoors, and privacy-enhanced tinted mirror glass windows. Additional amenities include a wooden garage door with space for two cars, a separate laundry room, and stylish furnishings from top Italian and French brands.
Reference:
493867 - HRB-00286PSize:
291m²Plot size:
453m²Bedrooms:
4Bathrooms:
5Furnished:
Fully furnishedSwimming pool:
PrivateGarden:
Comunitary Furnished kitchen:
Furnished with appliancesOrientation:
SoutheastAir conditioning:
ColdNo. of floors:
1Condition:
ExcellentEquipment:
Floor heating (total), Intercom
530.000€
Spectacular house in the iconic La Heredia Urbanization.
The house has a spacious living room with high wooden ceilings and a fireplace that give a charming and unique touch to this home, a kitchen open to the living room, completely renovated and equipped with high-end appliances, 3 en-suite bedrooms with built-in wardrobes, plus a toilet in the entrance hall.
Central air conditioning hot and cold, fireplace.
The urbanization has 2 communal swimming pools, one of them heated and the other with impressive panoramic views.
Spectacular common areas, bar and restaurant with mini market in the same urbanization. 24 hour security with checkpoint and security barrier.
Just 10 minutes from San Pedro and Puerto Banús.
Reference:
493866Size:
142m²Bedrooms:
3Bathrooms:
4Furnished:
Fully furnishedSwimming pool:
ComunitaryGarden:
Comunitary Furnished kitchen:
Furnished with appliancesTerraces:
(20.00m²)Orientation:
South, SouthwestHeating:
CentralizedAir conditioning:
ColdNo. of floors:
2Condition:
ExcellentEquipment:
Water, Light, ChimneySecurity measures:
Alarm
13.500.000€
Welcome to Cerquilla 10, a cutting-edge estate in one of Marbella's most exclusive residential
communities, La Cerquilla. This frontline golf mansion in the heart of the Golf Valley, is set on a
private plot with picturesque views to the greens of Los Naranjos Golf Course. Cerquilla 10 is a
luxurious home boasting a stunning open-plan layout, optimised for comfort and offering the
latest design trends. Designed by renowned Tobal Architects and exquisitely furnished by
respected Pedro Peña, Cerquilla 10 is a true masterpiece and probably the most luxurious
mansion currently built in La Cerquilla. Among its luxurious features we can highlight a state-of-
the-art cinema, yoga & gym room, heated pool and Jacuzzi, children play room, the latest
domotic technology, separate staff apartment, main gourmet kitchen and chef's kitchen.
Cerquilla 10 has been designed to impress the most discerning buyer and will take your breath
away as soon as you step in.
Reference:
493865Size:
1.033m²Plot size:
2.342m²Bedrooms:
6Bathrooms:
7Terraces:
(410.00m²)No. of floors:
3
3.800.000€
Brand-new property for sale in Paraiso Alto that will be ready for you by the end of 2023. The villa has a dynamic design with an open plan concept, geometric shapes and clean lines of style. The house offers six bedrooms, six bathrooms, guest toilet, large living and dining areas, a fully equipped American style kitchen with high quality appliances. On the lower floor it will be possible to have a wine cellar, a wellness area with a gym, spa and sauna. The villa will have huge windows with double height ceilings and glass doors will give you an amazing feeling of light and lightness. The impressive pool with waterfall will be covered with a special stone from Indonesia that purifies the water. An automatic irrigation system will be installed in the garden. The house also provides - a guest room, laundry room, pantry and dressing room, elevator, studio, separate guest toilet and a private garage that will accommodate three of your cars. Amenities include a digital video intercom, air conditioning and underfloor heating, Smart Home, a unique glass fireplace, built-in wardrobes and more. The villa is located in the exclusive residential complex 'El Paraiso Alto', surrounded by several golf courses, is located in the quiet valley of El Paraiso.
Reference:
493864 - 4273MLVSize:
1.038m²Plot size:
1.915m²Bedrooms:
6Bathrooms:
7Garage:
PrivateSwimming pool:
PrivateGarden:
Comunitary Air conditioning:
ColdNo. of floors:
1Condition:
ExcellentEquipment:
Floor heating (total), Chimney, Intercom
879.000€
a well-priced 5 bedroom Villa with garage with lots of possibilities in one of the better areas of Elviria with sea views, the villa has 5 bedrooms, a large living room and large kitchen, both with access to a large terrace, the swimming pool is 5x 8 meters and heated next to the house is a private piece of land of 100 meters which gives the possibility to create a guest house or an office.
This house has all the possibilities to easily expand and create a villa with a modern look, with the possibility of creating a large BBQ terrace on the existing flat roof with amazing mountain & sea views.
Elviria is a popular residential community located in the eastern part of Marbella, about 15 minutes' drive to Marbella city centre and 25 minutes' drive to the international airport of Malaga. Some of the best international schools are situated in Elviria such as the English International College, the Deutsche Schule and Colegio Ecos. The area is well equipped with services, restaurants, supermarkets and entertainment facilities. Also conveniently located are the Santa María and Santa Clara golf courses with their respective clubs and two more golf courses, Golf Club Marbella and Golf Rio Real, are only a short drive away. Elviria offers beautiful sandy beaches with charming beach restaurants and the famous beach club Nikki Beach is situated just next to the five-star luxury Hotel Don Carlos.
Reference:
493863Size:
336m²Plot size:
980m²Bedrooms:
5Bathrooms:
3Furnished:
Fully furnishedGarage:
PrivateSwimming pool:
PrivateFurnished kitchen:
Furnished with appliancesTerraces:
(90.00m²)Heating:
CentralizedAir conditioning:
ColdNo. of floors:
2Condition:
Average
575.000€
Immense Penthouse in the exclusive Plaza De La Hispanidad Fuengirola for sale.
Truly something special. about 300sq of flat on two levels,
4 bedrooms, 3 bahrooms.
First level has a huge lving room, seperate big kitchen, covered balcony with a barbeque space and a toilet.
The level about has all 4 bedrooms, a utility space on the big terrace, and 2 bathroom one en suite with big shower and jacuzzi.
Aircondition, garage and comunal swiiming pool incuded.
Unbeatable area. close to all kinds of restauratns, shops and bars. walking distance to the train station as well as to the beach.
For any more information or to organize a viewing get in touch with one of our agents!
Reference:
493862Size:
205m²Bedrooms:
4Bathrooms:
3Furnished:
Partially furnishedGarage:
PrivateSwimming pool:
ComunitaryGarden:
Comunitary Furnished kitchen:
Furnished with appliancesTerraces:
(17.00m²)Orientation:
SouthwestHeating:
CentralizedAir conditioning:
ColdNo. of floors:
2Condition:
ExcellentEquipment:
Phone line, Water, Light, GasBajamar, San Cristóbal de la Laguna, Santa Cruz de Tenerife, Tenerife
Apartment for rent
FOR RENT
850€
(£ 745 app.)
Calle Montalmar, 31
Welcome to this wonderful duplex on the fifth floor with excellent views! The apartment has been recently renovated and has a fully furnished American kitchen open to the living room, which makes it perfect for enjoying the company of friends and family.
The complex has community gardens, swimming pool, gym, reading room, barbecue, elevator, Wi-Fi and parking space, everything you need to enjoy a comfortable and relaxing stay. Also, if you have pets, we can talk about it.
The property has 55 m² built and 50 m² useful, 1 bedroom, 1 bathroom, and terrace. In addition, it has built-in wardrobes for greater storage.
Don't miss the opportunity to live in this beautiful penthouse! Contact us for more information and to schedule a visit.
Reference:
493861 - ALQ BJMRSize:
52m²Usable size:
50m²Bedrooms:
1Bathrooms:
1Furnished:
Fully furnishedGarage:
Comunitary (1 Parking places)Garage type:
CarportSwimming pool:
ComunitaryGarden:
Comunitary Built-in cupboards:
YesFurnished kitchen:
Furnished with appliancesKitchen type:
AmericanTerraces:
1 Hot water:
IndividualType hot water:
Electric heaterAir conditioning:
Cold-heatLift:
YesUrbanization:
PrivateCondition:
ExcellentAvailability:
UnoccupiedEquipment:
TV, Refrigerator, Washing machine, Oven, Microwave, Light, Appliances, Ceramic hob, Shower plateSport facilities:
Gym
JUST IN!
88.000€
Reference:
493859 - fc351Size:
95m²Usable size:
90m²Plot size:
400m²Bedrooms:
3Garage:
Private (2 Parking places)Independent dining room:
(25.00m²)Terraces:
1 (15.00m²)Orientation:
SouthStorage room:
YesScale consumption efficiency:
GEquipment:
Light, Barbecue, Chimney
JUST IN!
100.000€
Reference:
493858 - FC350Size:
75m²Usable size:
70m²Plot size:
15.000m²Bedrooms:
1Independent dining room:
(20.00m²)Terraces:
1 (15.00m²)Orientation:
SouthBuilding year:
1995 (29 year/s)Condition:
To renovate/moderniseScale consumption efficiency:
G
JUST IN!
790€
(£ 693 app.)
Reference:
493857 - 41393Size:
90m²Usable size:
75m²Bedrooms:
3Garage:
Comunitary (2 Parking places)Swimming pool:
ComunitaryBuilt-in cupboards:
YesIndependent dining room:
(0.00m²)Terraces:
(0.00m²)Balconies:
1 Orientation:
NorthHeating:
IndividualAir conditioning:
ColdNo. of floors:
4Lift:
YesBuilding year:
2024 (0 year/s)Condition:
New buildScale consumption efficiency:
GEquipment:
Phone line, Video intercom, Light
JUST IN!
64.900€
Reference:
493856 - 41391Size:
60m²Usable size:
0m²WCs:
2Terraces:
(0.00m²)Orientation:
NorthNo. of floors:
7Building year:
1972 (52 year/s)Condition:
Renovated/modernisedScale consumption efficiency:
GEquipment:
Phone line, Light
JUST IN!
378.000€
Reference:
493855 - 41390Size:
169m²Usable size:
142m²Bedrooms:
4Independent dining room:
(0.00m²)Terraces:
1 (0.00m²)Courtyards:
1Storage room:
YesLift:
YesBuilding year:
1963 (61 year/s)Condition:
To renovate/moderniseScale consumption efficiency:
GEquipment:
LightHandicapped access:
Yes
JUST IN!
350€
(£ 307 app.)
Reference:
493854 - 41389Size:
32m²Usable size:
29m²Furnished:
Fully furnishedSwimming pool:
ComunitaryTerraces:
(0.00m²)Air conditioning:
ColdNo. of floors:
3Lift:
YesBuilding year:
2010 (14 year/s)Condition:
GoodScale consumption efficiency:
GEquipment:
LightHandicapped access:
YesComunity fee:
(community fee included)
JUST IN!
720€
(£ 631 app.)
Reference:
493853 - 41388Size:
91m²Usable size:
83m²Bedrooms:
2Furnished:
Fully furnishedGarage:
Comunitary (2 Parking places)Lounges:
1Independent dining room:
(0.00m²)Terraces:
(0.00m²)Orientation:
WestStorage room:
YesAir conditioning:
ColdNo. of floors:
3Lift:
YesBuilding year:
2021 (3 year/s)Scale consumption efficiency:
GEquipment:
Video intercom, LightSecurity measures:
Security doorHandicapped access:
YesComunity fee:
(community fee included)
JUST IN!
79.900€
Reference:
493852 - 41387Size:
82m²Usable size:
74m²Bedrooms:
5Furnished:
Fully furnishedGarage:
Comunitary (2 Parking places)Independent dining room:
(0.00m²)Terraces:
(0.00m²)Balconies:
1 Heating:
IndividualAir conditioning:
ColdBuilding year:
1985 (39 year/s)Condition:
Renovated/modernisedScale consumption efficiency:
GEquipment:
Phone line, LightComunity fee:
40€
JUST IN!
600€
(£ 526 app.)
Reference:
493851 - 41386Size:
98m²Usable size:
0m²WCs:
1Terraces:
1 (0.00m²)Urbanization:
PrivateBuilding year:
1989 (35 year/s)Condition:
GoodScale consumption efficiency:
GHandicapped access:
YesComunity fee:
(community fee included)
JUST IN!
700€
(£ 614 app.)
Reference:
493850 - 41385Size:
130m²Usable size:
105m²Bedrooms:
2Built-in cupboards:
YesIndependent dining room:
(0.00m²)Terraces:
1 (80.00m²)Courtyards:
1Building year:
1951 (73 year/s)Scale consumption efficiency:
GEquipment:
LightSecurity measures:
Alarm
JUST IN!
80.000€
Reference:
493848 - 41382Size:
104m²Usable size:
92m²Plot size:
122m²Bedrooms:
213Independent dining room:
(0.00m²)Terraces:
1 (0.00m²)Courtyards:
1Building year:
1955 (69 year/s)Condition:
To renovate/moderniseScale consumption efficiency:
GEquipment:
Chimney
JUST IN!
700€
(£ 614 app.)
Reference:
493847 - 40293Size:
100m²Usable size:
90m²Bedrooms:
3Furnished:
Fully furnishedGarage:
Comunitary (2 Parking places)Lounges:
1Built-in cupboards:
YesIndependent dining room:
(0.00m²)Terraces:
1 (50.00m²)Storage room:
YesHeating:
IndividualAir conditioning:
ColdNo. of floors:
2Lift:
YesBuilding year:
2009 (15 year/s)Condition:
GoodScale consumption efficiency:
GEquipment:
Phone line, LightComunity fee:
(community fee included)
JUST IN!
89.000€
Parque de las Unidas, Calle Tomillo Third floor apartment with elevator renovated house of 55 m2 built with 1 bedroom, bathroom, separate kitchen, large living room and terrace, the house is sold with its garage space, has air conditioning and is sold furnished .~
Reference:
493846 - COR2769Size:
50m²Usable size:
46m²Bedrooms:
1Furnished:
Fully furnishedTerraces:
(0.00m²)Balconies:
1 Lift:
YesBuilding year:
2003 (21 year/s)Scale consumption efficiency:
GComunity fee:
45€
GOOD DEAL
1.100€
(£ 965 app.)
Calle Verónica de la virgen
Reference:
493834Size:
64m²Usable size:
64m²Bathrooms:
1Furnished:
Fully furnishedFloor:
1stFurnished kitchen:
Furnished with appliancesKitchen type:
AmericanLocation:
ExteriorOrientation:
SouthLocation:
City centerViews:
StreetCeiling height:
RegularType of ceiling:
PlasterWalls:
FlatFloors:
Porcelain stonewareType of windows:
GlazedType of glazing:
Double glazingHot water:
YesType hot water:
Electric heaterHeating:
YesHeating type:
Natural gasAir conditioning:
Cold-heatNo. of floors:
3Lift:
YesNeighbors in the building:
9Style:
ModernBuilding year:
1984 (40 year/s)Condition:
ExcellentAvailability:
RentedEquipment:
TV, Refrigerator, Washing machine, Dryer, Dishwasher, Oven, Microwave, Water, Light, Intercom, Ceramic hob, Shower plate, Dressing roomSecurity measures:
Security doorRental purpose:
Family, WorkersRental bond:
1.100€Comunity fee:
(community fee included)New properties
Would you like to receive by email the properties we include in the website?
Selected: 13549 properties« backnext »